#!/bin/sh


sqoop export \
--connect jdbc:mysql://node101:3306/xm1_lx \
--username root \
--password 123456 \
--num-mappers 1 \
--export-dir /user/spark/warehouse/zg6_xm1_lx/ads \
--table traffic_view_report \
--update-key "dt,province_name,city_name,recent_days" \
--update-mode allowinsert \
--input-fields-terminated-by '\001' \
--input-null-non-string '\\N' \
--input-null-string '\\N'











